object dmGermax: TdmGermax
  OldCreateOrder = False
  Height = 395
  Width = 591
  object germaxConn: TSQLConnection
    ConnectionName = 'germax'
    DriverName = 'FIREBIRD'
    GetDriverFunc = 'getSQLDriverINTERBASE'
    LibraryName = 'dbxfb.dll'
    LoginPrompt = False
    Params.Strings = (
      'drivername=FIREBIRD'
      'Database=D:\GerMAx\branches\GerMaxNFe\Dados\germax.gdb')
    VendorLib = 'fbclient.DLL'
    Connected = True
    Left = 32
    Top = 8
  end
  object dtsPessoa: TSQLDataSet
    CommandText = 'select * from PESSOAS'
    DbxCommandType = 'Dbx.SQL'
    MaxBlobSize = -1
    Params = <>
    SQLConnection = germaxConn
    Left = 32
    Top = 64
    object dtsPessoaID: TIntegerField
      FieldName = 'ID'
      ProviderFlags = [pfInUpdate, pfInWhere, pfInKey]
      Required = True
    end
    object dtsPessoaTIPO: TStringField
      FieldName = 'TIPO'
      ProviderFlags = [pfInUpdate]
      Required = True
      FixedChar = True
      Size = 1
    end
    object dtsPessoaNOME: TStringField
      FieldName = 'NOME'
      ProviderFlags = [pfInUpdate]
      Required = True
      Size = 50
    end
    object dtsPessoaAPELIDO: TStringField
      FieldName = 'APELIDO'
      ProviderFlags = [pfInUpdate]
      Size = 50
    end
    object dtsPessoaCPF: TStringField
      FieldName = 'CPF'
      ProviderFlags = [pfInUpdate]
    end
    object dtsPessoaRG: TStringField
      FieldName = 'RG'
      ProviderFlags = [pfInUpdate]
    end
    object dtsPessoaID_ENDERECO: TIntegerField
      FieldName = 'ID_ENDERECO'
      ProviderFlags = [pfInUpdate]
    end
    object dtsPessoaID_ENDERECO_COBRANCA: TIntegerField
      FieldName = 'ID_ENDERECO_COBRANCA'
      ProviderFlags = [pfInUpdate]
    end
    object dtsPessoaID_ENDERECO_ENTREGA: TIntegerField
      FieldName = 'ID_ENDERECO_ENTREGA'
      ProviderFlags = [pfInUpdate]
    end
  end
  object dtsCliente: TSQLDataSet
    SchemaName = 'sysdba'
    CommandText = 'select *  from CLIENTES'#13#10'where ID_PESSOA =:IDPESSOA'
    DbxCommandType = 'Dbx.SQL'
    MaxBlobSize = -1
    Params = <
      item
        DataType = ftInteger
        Name = 'IDPESSOA'
        ParamType = ptInput
      end>
    SQLConnection = germaxConn
    Left = 152
    Top = 64
    object dtsClienteID_PESSOA: TIntegerField
      FieldName = 'ID_PESSOA'
      Required = True
    end
    object dtsClienteCADASTRO: TSQLTimeStampField
      FieldName = 'CADASTRO'
      ProviderFlags = [pfInUpdate]
    end
    object dtsClienteULTIMACOMPRA: TSQLTimeStampField
      FieldName = 'ULTIMACOMPRA'
      ProviderFlags = [pfInUpdate]
    end
    object dtsClienteSTATUS: TStringField
      FieldName = 'STATUS'
      ProviderFlags = [pfInUpdate]
      Required = True
      FixedChar = True
      Size = 1
    end
  end
  object dspPessoa: TDataSetProvider
    DataSet = dtsPessoa
    UpdateMode = upWhereKeyOnly
    Left = 40
    Top = 80
  end
  object dspCliente: TDataSetProvider
    DataSet = dtsCliente
    Options = [poPropogateChanges, poUseQuoteChar]
    UpdateMode = upWhereKeyOnly
    Left = 160
    Top = 80
  end
  object germaxLocal: TLocalConnection
    Left = 120
    Top = 8
  end
  object dtsEnderecos: TSQLDataSet
    SchemaName = 'sysdba'
    CommandText = 'select *  from  PESSOA_ENDERECOS'#13#10'where ID_PESSOA =:IDPESSOA'
    DbxCommandType = 'Dbx.SQL'
    MaxBlobSize = -1
    Params = <
      item
        DataType = ftInteger
        Name = 'IDPESSOA'
        ParamType = ptInput
      end>
    SQLConnection = germaxConn
    Left = 32
    Top = 128
    object dtsEnderecosID: TIntegerField
      FieldName = 'ID'
      ProviderFlags = [pfInWhere, pfInKey]
    end
    object dtsEnderecosID_PESSOA: TIntegerField
      FieldName = 'ID_PESSOA'
      ProviderFlags = [pfInUpdate]
      Required = True
    end
    object dtsEnderecosLOGRADOURO: TStringField
      FieldName = 'LOGRADOURO'
      ProviderFlags = [pfInUpdate]
      Required = True
      Size = 100
    end
    object dtsEnderecosNUMERO: TStringField
      FieldName = 'NUMERO'
      ProviderFlags = [pfInUpdate]
      Required = True
    end
    object dtsEnderecosCOMPLEMENTO: TStringField
      FieldName = 'COMPLEMENTO'
      ProviderFlags = [pfInUpdate]
      Size = 50
    end
    object dtsEnderecosBAIRRO: TStringField
      FieldName = 'BAIRRO'
      ProviderFlags = [pfInUpdate]
      Size = 50
    end
    object dtsEnderecosCIDADE: TStringField
      FieldName = 'CIDADE'
      ProviderFlags = [pfInUpdate]
      Size = 50
    end
    object dtsEnderecosESTADO: TStringField
      FieldName = 'ESTADO'
      ProviderFlags = [pfInUpdate]
      Size = 50
    end
    object dtsEnderecosCEP: TStringField
      FieldName = 'CEP'
      ProviderFlags = [pfInUpdate]
      Size = 10
    end
  end
  object dspEnderecos: TDataSetProvider
    DataSet = dtsEnderecos
    Options = [poPropogateChanges, poUseQuoteChar]
    UpdateMode = upWhereKeyOnly
    Left = 40
    Top = 144
  end
end
